package com.cchip.cloud.db;

import android.provider.BaseColumns;

public interface LogColumns extends BaseColumns {
	public static final String ID = "roomid";
	public static final String NAME = "roomname";
	public static final String DATE = "date";
	public static final String TIME = "time";
	public static final String STAMP = "stamp";

	public static final int INDEX_ID = 1;
	public static final int INDEX_NAME = 2;
	public static final int INDEX_DATE = 3;
	public static final int INDEX_TIME = 4;
	public static final int INDEX_STAMP = 5;

	public static final String DATABASE_TABLE_NAME = "log";
	public static final String DATABASE_DROP_SQL = "DROP TABLE IF EXISTS "
			+ DATABASE_TABLE_NAME;

	public static final String DATABASE_CREATE_TABLE_SQL = "CREATE TABLE "
			+ DATABASE_TABLE_NAME + " (" + _ID + " INTEGER PRIMARY KEY," + ID
			+ " TEXT," + NAME + " TEXT," + DATE + " TEXT," + TIME + " TEXT,"
			+ STAMP + " LONG);";

}
